Enterprise Database Systems
DA-100: Analyze and Share Data with Power BI
DA-100: Analysis & Sharing Features in Power BI
it_dfapbi_01_enus
DA-100: Applying Power BI's Advanced Analysis Features
it_dfapbi_03_enus
DA-100: Extracting Insights from Data Using Power BI
it_dfapbi_02_enus
DA-100: Sharing Power BI Reports & Workspaces
it_dfapbi_04_enus
DA-100: Analysis & Sharing Features in Power BI
Lesson Objectives
DA-100: Analysis & Sharing Features in Power BI
- discover the key concepts covered in this course
- recognize the different phases and roles involved when building and sharing Power BI reports
- identify the features available in Power BI to collaborate with other developers and share reports with end users
- describe the Power BI features available to develop and share reports and dashboards
- recall the steps involved in preparing for and taking the DA-100 certification exam for data analysis
- load a dataset into Power BI Desktop for analysis
- use a scatter chart to identify outliers in your dataset
- use a scatter chart to find outliers within categories of your dataset
- write a DAX expression to identify outliers
- summarize the key concepts covered in this course
Overview/Description
Analyzing data can throw light on game-changing insights. To action these insights, it's imperative the appropriate data is shared with the right people. Learn how to analyze and share data using Power BI in this DA-100 preparatory course. Explore considerations when building Power BI reports and collaborating with others. Learn how to streamline report deployment and sharing using Power BI pipelines, which help manage large and complex report deployments. And examine critical practices for securing reports by limiting the data accessible to viewers. Moving on, examine essentials to keep in mind when preparing for the DA-100 certification. Finally, get hands-on with Power BI Desktop, performing some preliminary analysis to identify outliers in your data. Upon completion, you'll know how to analyze data and share reports competently. You'll also be more prepared for the DA-100 certification exam.
Analyzing data can throw light on game-changing insights. To action these insights, it's imperative the appropriate data is shared with the right people. Learn how to analyze and share data using Power BI in this DA-100 preparatory course. Explore considerations when building Power BI reports and collaborating with others. Learn how to streamline report deployment and sharing using Power BI pipelines, which help manage large and complex report deployments. And examine critical practices for securing reports by limiting the data accessible to viewers. Moving on, examine essentials to keep in mind when preparing for the DA-100 certification. Finally, get hands-on with Power BI Desktop, performing some preliminary analysis to identify outliers in your data. Upon completion, you'll know how to analyze data and share reports competently. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
DA-100: Applying Power BI's Advanced Analysis Features
Lesson Objectives
DA-100: Applying Power BI's Advanced Analysis Features
- discover the key concepts covered in this course
- build a column chart to analyze the distribution of values across categories and the Analyze feature to identify situations where the distribution is different
- use the Analyze feature of line charts to explain plausible reasons for an increase or decrease in a metric
- apply the forecasting feature in a line chart to estimate future values based on past patterns
- find anomalies in a time series by using and configuring the anomaly detection feature in Power BI
- include and apply the Q&A visual in a report to enable users to extract insights by asking for it in plain English
- describe how query terms can be mapped to fields in a dataset for a Q&A visual
- construct a decomposition tree to analyze a metric across various categories
- summarize the key concepts covered in this course
Overview/Description
It can be overwhelming to think about analyzing data to meet all pre-defined requirements. Luckily, advancements in technology can help with this analysis. Learn to use the Power BI features made possible by AI and other advanced techniques in this demo-based course. Use Power BI's Analyze feature to understand values and metrics in sales data. Apply the forecasting feature to a line chart to estimate future sales. Then find outliers in terms of daily sales using the anomaly detection feature. Next, use the Q&A visual to allow users to extract insights from data using plain English. Finally, create a decomposition tree to break down the sales data across different categories. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
It can be overwhelming to think about analyzing data to meet all pre-defined requirements. Luckily, advancements in technology can help with this analysis. Learn to use the Power BI features made possible by AI and other advanced techniques in this demo-based course. Use Power BI's Analyze feature to understand values and metrics in sales data. Apply the forecasting feature to a line chart to estimate future sales. Then find outliers in terms of daily sales using the anomaly detection feature. Next, use the Q&A visual to allow users to extract insights from data using plain English. Finally, create a decomposition tree to break down the sales data across different categories. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
DA-100: Extracting Insights from Data Using Power BI
Lesson Objectives
DA-100: Extracting Insights from Data Using Power BI
- discover the key concepts covered in this course
- apply different summary statistics to obtain different metrics from your data
- recognize how duplicated numeric values can be aggregated in visuals
- create groups out of the existing categorical values in a table field
- edit, manage, and use customized groups in visuals
- create groups out of a numeric field by binning the data points
- identify clusters in your data by using the clusters feature in Power BI
- recognize how to interpret clusters in your data and tweak Power BI's clustering algorithm for your data
- use the play axis feature of a Power BI scatter chart to enable chart animation and explore data at different points in time
- analyze data over a time series using a line chart and a slicer
- find the values in a categorical field that have the greatest influence on a numeric field in your data
- identify key influencers across multiple fields in your dataset
- find the range of values in a numeric field that serves as key influencers for a metric
- summarize the key concepts covered in this course
Overview/Description
Getting insights from data isn't always straightforward. However, using a tool like Power BI helps with heavy lifting. Through this hands-on course, learn to obtain insights from data using a combination of Power BI's visualization and analysis features. Explore how and why numeric data is summarized. Discover how the sum, mean, and median statistics, among others, give different views of the same data. Practice modeling data into customized groups to better represent it to end users. Use scatter charts to identify clusters and enable analysis of snapshots of data with a play axis. Finally, use the key influencers visual to identify how certain metrics are influenced by values in other fields. Upon completion, you'll know how to take advantage of the analytics features of Power BI visuals. You'll also be more prepared for the DA-100 certification exam.
Getting insights from data isn't always straightforward. However, using a tool like Power BI helps with heavy lifting. Through this hands-on course, learn to obtain insights from data using a combination of Power BI's visualization and analysis features. Explore how and why numeric data is summarized. Discover how the sum, mean, and median statistics, among others, give different views of the same data. Practice modeling data into customized groups to better represent it to end users. Use scatter charts to identify clusters and enable analysis of snapshots of data with a play axis. Finally, use the key influencers visual to identify how certain metrics are influenced by values in other fields. Upon completion, you'll know how to take advantage of the analytics features of Power BI visuals. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
DA-100: Sharing Power BI Reports & Workspaces
Lesson Objectives
DA-100: Sharing Power BI Reports & Workspaces
- discover the key concepts covered in this course
- add a new table to your Power BI model to map users to specific categories of data they can access
- implement and test row-level security in Power BI Desktop
- publish a report to a Power BI workspace and create an app for the workspace
- verify the implementation of row-level security when sharing an app with end users
- set varying levels of permissions on a Power BI workspace and recognize what operations are possible for each role
- allow users to access multiple categories of data when setting up row-level security
- map a workspace to the development stage of a Power BI pipeline and explore the lineage view of a workspace
- recall the steps involved in migrating to the different stages of a Power BI pipeline
- recognize the use cases for endorsing Power BI reports and dashboards
- use the performance analyzer feature in Power BI Desktop to identify potential performance bottlenecks in reports
- summarize the key concepts covered in this course
Overview/Description
Analyzing data and building reports is only useful if the right people can access and understand those reports. Take this course to learn how to involve others in your Power BI reports, be it collaborators in report development or consumers of your analysis. Begin by building a report configured with row-level security. Then, test it in Power BI Desktop before publishing it to the Power BI service. Via the Power BI service, share your workspace with teammates and other collaborators using different roles and permissions. Then use the Pipeline feature to streamline report deployment. Finally, learn to enhance report performance and collaboration by adding endorsements and using the native performance analyzer. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
Analyzing data and building reports is only useful if the right people can access and understand those reports. Take this course to learn how to involve others in your Power BI reports, be it collaborators in report development or consumers of your analysis. Begin by building a report configured with row-level security. Then, test it in Power BI Desktop before publishing it to the Power BI service. Via the Power BI service, share your workspace with teammates and other collaborators using different roles and permissions. Then use the Pipeline feature to streamline report deployment. Finally, learn to enhance report performance and collaboration by adding endorsements and using the native performance analyzer. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
